What is f4 on mac for excel?

F4 in Excel for Mac is a keyboard shortcut that can be used to repeat a formula or action by toggling between relative and absolute referencing.

When a cell reference is copied or dragged to another cell in Excel, it is by default a relative reference. This means that the reference changes based on the position of the new location. However, sometimes we want to keep a reference constant, such as when the reference points to a fixed value or a named range. That's where F4 comes in.

Pressing F4 after selecting a cell reference in a formula will cycle through the different reference types and add dollar signs ($) to the appropriate places. For example, if the reference is A1, pressing F4 will change it to $A$1 (absolute reference for both column and row), then to A$1 (absolute reference for row), then $A1 (absolute reference for column), and finally back to A1 (relative reference).

F4 can also be used to repeat the last action in Excel, such as formatting, deleting, or inserting rows or columns. This can save time and effort when performing repetitive tasks.

In summary, F4 is a powerful shortcut in Excel for Mac that helps to toggle between relative and absolute referencing and repeat the last action.